Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

Listbox height changing issue.zip

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Resources.zip

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...